Select Lesser Values Of An N Record From Every Distinct Value Of X

Use this option to filter records that have a lower value.

For example to see what customer in each household has the lowest Customer Profit Decile.

Procedure

1. On N per X, select the relevant option from the required table, for example One per Household ID from the Household or Customer table depending on requirement - See N per X & grid seg campaigns.htm.
2. In Using select the relevant field, for example Income.
3. Select the Allow 0s and Nulls to be selected check box.

This ensures that customers with a zero or null value will be returned.

If there is only one customer in the household, that customer will be selected.

• N per X
  • Selecting N records from every distinct value of X
  • Selecting N records from every distinct value of X using the greater value of a Sort Column
  • Select lesser values of an N record from every distinct value of X